MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Artist Alpha Sort = 11698

View and edit SQL

Suggested facets: Is Public Domain, Department, Artist Role, Artist Prefix, Object Date, Object Begin Date, Object End Date, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
118532 1985.311 0 1 207539 European Sculpture and Decorative Arts 3 Toast rack 905 Toast rack British, Birmingham and London 3384         Designer|Manufacturer 3 for firm of Christopher Dresser|Hukin & Heath British, Glasgow, Scotland 1834–1904 Mulhouse|British, Birmingham, 1855–1953   Dresser, Christopher|Hukin & Heath 11698 British, Scottish|British 347 1834 |1855 1904 |1953 1881 1881 1881 Silver plate 285 Overall: 5 × 6 3/4 × 4 in., 0.7 lb. (12.7 × 17.1 × 10.2 cm, 0.2948kg) Gift of Robert L. Isaacson, 1985                       Metalwork-Silverplate 335   Metropolitan Museum of Art, New York, NY 1
118801 1990.123.2 0 1 207824 European Sculpture and Decorative Arts 3 Wine bottle holder 8544 Wine bottle holder British, Sheffield 2294         Designer|Maker 4 for firm of Christopher Dresser|Hukin & Heath British, Glasgow, Scotland 1834–1904 Mulhouse|British, Birmingham, 1855–1953   Dresser, Christopher|Hukin & Heath 11698 British, Scottish|British 347 1834 |1855 1904 |1953 ca. 1880 1875 1885 Electroplated metal 23674 Height: 7 7/8 in. (20 cm) Purchase, Robert L. Isaacson Gift, 1990                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
121097 2000.594.1a, b–.8 0 1 210643 European Sculpture and Decorative Arts 3 Traveling tea set 8671 Traveling tea set British, Birmingham 398         Designer|Maker 4 for the firm of Christopher Dresser|Hukin & Heath British, Glasgow, Scotland 1834–1904 Mulhouse|British, Birmingham, 1855–1953   Dresser, Christopher|Hukin & Heath 11698 British, Scottish|British 347 1834 |1855 1904 |1953 ca. 1879 1874 1884 Gilt and silver-plated brass; split bamboo; leather covered wood with velvet on the underside and glazed cotton linings 24231 Height (tea kettle): 4 3/8 in. (11.1 cm); Height (spirit lamp): 1 3/8 in. (3.5 cm); Height (stand): 3 3/8 in. (8.6 cm); Height (teapot): 3 1/2 in. (8.9 cm); Height (sugar bowl): 2 1/8 in. (5.4 cm); Height (milk jug): 2 in. (5.1 cm); Height (tea caddy): 2 3/8 in. (6 cm) Anonymous Gift, in memory of Walter E. Stait, 2000                       Metalwork-Silverplate 335   Metropolitan Museum of Art, New York, NY 1
121183 L.2004.64.1a–c 0 0 210742 European Sculpture and Decorative Arts 3 Tureen and ladle 8705 Tureen and ladle British, London 222         Designer|Manufacturer 3   Christopher Dresser|Hukin & Heath British, Glasgow, Scotland 1834–1904 Mulhouse|British, Birmingham, 1855–1953   Dresser, Christopher|Hukin & Heath 11698 British, Scottish|British 347 1834 |1855 1904 |1953 ca. 1880 1875 1885 Electroplate (silver on yellow metal); ivory 24235 Overall (tureen): 8 × 9 in. (20.3 × 22.9 cm); Length (ladle): 13 3/4 in. (34.9 cm) Promised gift of Paul F. Walter, 1991                       Metalwork-Silverplate 335   Metropolitan Museum of Art, New York, NY 1
335131 1982.514 0 1 482591 Modern and Contemporary Art 4 Toast or letter rack 15143 Toast or letter rack           Designer|Manufacturer 3   Christopher Dresser|Hukin & Heath British, Glasgow, Scotland 1834–1904 Mulhouse|British, Birmingham, 1855–1953   Dresser, Christopher|Hukin & Heath 11698 British, Scottish|British 347 1834 |1855 1904 |1953 1881 1881 1881 Electroplated silver 23593 H. 4-3/4, W. 6-1/2, D. 4-1/8 in. (12.1 x 16.5 x 10.5 cm.) Gift of Jean and Martin Mensch, 1982                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 254.468ms · Data license: CC0 · Data source: metmuseum/openaccess